Working with Tables
The Pixel-perfect Reports Builder provides two options for displaying tabular data:
- Simple tables
- Dynamic tables
Simple tables display one object per table cell, which can be either static text or text resolved from a token. If you add a dataset column to a simple table, the cell displays the first record found in the dataset. Dynamic tables, on the other hand, are much more powerful for displaying datasets. A dynamic table adds a row for each record in the dataset column. Unlike simple tables, you cannot add static text to the cells of a dynamic table, with the exception of the header row.
You can only add tables to the Body of the report.
Simple Tables
Simple tables display one object per table cell, which can be either static text or text resolved from a token. If you add a dataset column to a simple table, the cell displays the first record found in the dataset.
To add a simple table
Click the Simple Table icon in the toolbar.
Navigate to the body of the canvas and draw a bounding box for the table. A blank table displays and the Configuration panel updates to display Simple Table Configuration options.
In the Simple Table Configuration panel, specify the desired number of Columns and Rows in the fields provided. Expand the table as needed on the canvas to accommodate the number of columns and rows.
- You can add and delete rows by clicking the dropdown menu in the header box of each row and selecting a delete or insert option.
- You can add and delete columns by clicking the dropdown menu in the header box of each column and select a delete or insert option.
To add static text to a table cell, click in the cell and type your text. Use the settings in the Simple Table Cell Configuration panel to format the text.
To add a token to a table cell, click the Token symbol
{}
in the desired cell, and select an option from the dropdown menu. A string displays in the text box, which the system uses to resolve the token. You can only add one token per cell.Format the table as desired using the Border and Padding settings in the Simple Table Cell Configuration panel.
Note: At any time, you may click Preview to preview the report. The Preview feature displays the actual data in the table.
Dynamic Tables
Dynamic tables are much more powerful than simple tables for displaying datasets. A dynamic table adds a row for each record in the dataset column. Unlike simple tables, you cannot add static text to the cells of a dynamic table, with the exception of the header row.
To add a dynamic table
Click the Dynamic Table icon in the toolbar.
Navigate to the body of the canvas and draw a bounding box for the table. A blank table displays and the Configuration panel updates to display Dynamic Table Configuration options.
In the Dynamic Table Configuration panel, click the Style tab and specify the desired number of Columns and Rows in the fields provided. Expand the table as needed on the canvas to accommodate the number of columns and rows.
- You can add and delete rows by clicking the dropdown menu in the header box of each row and selecting a delete or insert option.
- You can add and delete columns by clicking the dropdown menu in the header box of each column and select a delete or insert option.
To add a header, click in the table cell, enter your text, and use the options in the Dynamic Table Cell Config panel to format the text.
To add a token to a table cell, click the Token symbol
{}
in the desired cell, and select an option from the dropdown menu. A string displays in the text box, which the system uses to resolve the token. You can only add one token per cell.Continue to design your table. Use the following advanced features as needed:
- To add a column to a table cell, see the section below called, "Add column data to a dynamic table".
- To add a group to a table cell, see the section below called, "Add groups to a dynamic table".
- To add a table total, see the section below called, "Add totals to a dynamic table".
Format the table as desired using the options on the Style tab.
Note: At any time, you may click Preview to preview the report. The Preview feature displays the actual data in the table.
To alternate colors in a dynamic table
Dynamic tables enable you to define alternating font and background colors to make the table easier to read. By default, alternate colors are not applied. To define alternating colors:
- Select the table to display its Configuration panel.
- Click the Style tab, and configure the following settings:
- Font Color
- Background Color
- Alternate Font Color
- Alternate Background Color The alternating colors will be applied when the table is displayed, previewed, and exported.
Add column data to a dynamic table
Select the table on the canvas by clicking its Grabber handle.
Display the Data & Parameters panel and open the Data tab.
Display the Dynamic Table Configuration panel and open the Data tab. If the Data tab is not displayed, try clicking the Drag handler to select the table and refresh the Dynamic Table Configuration panel.
Drag the desired column from the Data & Parameters panel to the Columns shelf on the Dynamic Table Configuration panel. The column name displays in the table on the canvas.
Continue to add columns to the Column shelf.
Change the order of the columns as needed. Drag the column names up and down in the Column shelf.
To remove a column, drag it away from the Column shelf.
Click Preview to preview the report using the data selected.
Add groups to a dynamic table
Select the table on the canvas by clicking its Grabber handle.
Display the Data & Parameters panel and open the Data tab.
Display the Dynamic Table Configuration panel and open the Data tab. If the Data tab is not displayed, try clicking the Drag handler to select the table and refresh the Dynamic Table Configuration panel.
Drag the desired column from the Data & Parameters panel to the Groups shelf on the Dynamic Table Configuration panel. The group name displays in the table on the canvas.
Continue to add columns to the Groups shelf.
Change the order of the columns as needed. Drag the column names up and down in the Group shelf.
To remove a column, drag it away from the Group shelf.
Click Preview to preview the report using the data selected.
Add totals to a dynamic table
Verify that the table is positioned on the canvas with sufficient empty space below it to fit an additional row.
Select the table on the canvas by clicking its Grabber handle.
Display the Dynamic Table Configuration panel and open the Data tab. If the Data tab is not displayed, try clicking the Drag handler to select the table and refresh the Dynamic Table Configuration panel.
Under Totals, click Add Total. A new row displays at the bottom of the table, which will display the total for each column.
In the Dynamic Table Configuration panel, click the dropdown arrow next to the Total you just added. It expands to display settings.
Use the options provided to customize how the totals are displayed. You can also click Remove to remove the Total.
Click Preview to preview the report using the data selected.
See also: